'use strict'

const pg = require('pg');

let psql = new pg.Pool({
    database:'zmh',
    user:'zmh',
    port:5432,
    host:'127.0.0.1',
    password:'123456',
    max:5  //最大使用5个客户端连接
});

(async () => {
    let time = Date.now();

    //随机数字转成16进制并去掉前两位
    let id = `${Math.random().toString(16).substring(2)}`;
    let sqltext = `INSERT INTO` + ` content(id,detail,title,add_time,update_time)` + ` VALUES($1,$2,$3,$4,$5)`;

    let r = await psql.query(sqltext,[
        id, `测试内容：${Math.random()}`, 'test',
        time, time
    ])
    console.log(r);
    //关闭连接
    psql.end();
})();